UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xkwmrYnINiBrp8qXdNIhF5ejJjpnEJJRdp+mIXinEcg='
WHERE
key_id = 'd4c4de2ea9ce592ed75ad595bfa62dc8b017d8c9286405ede2a8359faa10e313'
AND (
token = 'xkwmrYnINiBrp8qXdNIhF5ejJjpnEJJRdp+mIXinEcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)