UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NY0ScSg3G6LL4v+38J5+ejuH0VHQkCAb95ZPzaXEYTA='
WHERE
key_id = 'cafe8608339591fbe5c8a6d33a072d581c22c04e35e9ea13a4845ac2d8e77af3'
AND (
token = 'NY0ScSg3G6LL4v+38J5+ejuH0VHQkCAb95ZPzaXEYTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)