UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/JiFZJnwMbaYRJVLR7GiQZ9Df5xcZwDDhYd8f5wSqs4='
WHERE
key_id = '908a01ec6d6499e72eebc649c9537fd6a60c2ee8f00954b002b70079a9d5369a'
AND (
token = '/JiFZJnwMbaYRJVLR7GiQZ9Df5xcZwDDhYd8f5wSqs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)