UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cEr+zKrB7EddoRJot3IY+5DvCjlzdHKrOqbI4RO6R5A='
WHERE
key_id = '4ce068cf9cb436004f317b6ef0e010e3a291f516531cc81f20c26350b8841a68'
AND (
token = 'cEr+zKrB7EddoRJot3IY+5DvCjlzdHKrOqbI4RO6R5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)