UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P95IUgEna60dLT/c/KsZq3xSn66v1wAi0S1ufa0dciU='
WHERE
key_id = '8e5cdb772a6fee702e9a55e0bcb36541e698e09938dba749ee4e2cb61cc3b679'
AND (
token = 'P95IUgEna60dLT/c/KsZq3xSn66v1wAi0S1ufa0dciU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)