UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1C9klPCl5uSpm9V+Vxt1wkMegxsm3Io2lT8gej0ZVKo='
WHERE
key_id = '8039e83bacd9b7aa7952414439c04babea22291df75512e593505353a7dc5dcd'
AND (
token = '1C9klPCl5uSpm9V+Vxt1wkMegxsm3Io2lT8gej0ZVKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)