UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gOjnOptHpI5EkzWj6SIa1DrR5sWkaiOdhEm7QfnDn3w='
WHERE
key_id = 'eab64be5f63fe98fddee5c2bf312c3726c2842e071470176431922e8c3243fb8'
AND (
token = 'gOjnOptHpI5EkzWj6SIa1DrR5sWkaiOdhEm7QfnDn3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)