UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ng9snK44LR72DM6BgEHELu/jeTZLS/H+pcWOzL+e1yc='
WHERE
key_id = '9fee2760eb1411b160bf9698e376dc8ffd2ecb2e99c934e2ae4e69a028a9f169'
AND (
token = 'Ng9snK44LR72DM6BgEHELu/jeTZLS/H+pcWOzL+e1yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)