UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8OQUz46OEEAnSP6EI6jLW6W8t0VDKQrCyjlhONO0YjU='
WHERE
key_id = '8e5fdd2fa14fcf61f91489d078edfdb6d4e0af593d19191c65bb8d07140abfa1'
AND (
token = '8OQUz46OEEAnSP6EI6jLW6W8t0VDKQrCyjlhONO0YjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)