UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ngh0oLz62xY1QrS7Dcc/X7md2pkFxFPGO/ogZmKIV8I='
WHERE
key_id = 'f3842567d22e01751aaec218adbfad472b460b3ad251b5e175a87feb2d45a6b6'
AND (
token = 'Ngh0oLz62xY1QrS7Dcc/X7md2pkFxFPGO/ogZmKIV8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)