UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zNsM78Q7WTCDK3WBq7H00GmSFCOsSXVM517IBzOWjI='
WHERE
key_id = 'cc5091f5d73a1da744a9e74427e1988ec64c013f98462c2819467b6d4e8107f7'
AND (
token = '9zNsM78Q7WTCDK3WBq7H00GmSFCOsSXVM517IBzOWjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)