UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JU5kDR554hmjBhZz3JBnRajpUUixUeelVubmITHbrho='
WHERE
key_id = '1fd989068eace8bb397ca01b9284653fd59e25cd2013e8557af3f6e30b519c1c'
AND (
token = 'JU5kDR554hmjBhZz3JBnRajpUUixUeelVubmITHbrho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)