UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDxcW/EVGKPbPo0USIGftAwNcVWMWZK8DL4DYyymMfw='
WHERE
key_id = 'd35db8917558adc7ca37573cd52dc2d1c5c4671291e7850bfcd26ea150ed94ab'
AND (
token = 'zDxcW/EVGKPbPo0USIGftAwNcVWMWZK8DL4DYyymMfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)