UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KbqvSinq5lqzpYa4WkbgNQTCS6Hnq5zVjDd/esMiw00='
WHERE
key_id = '1a17c1eb4412d128a30710c9e21931d5900f503c9c7d08c69a9a4f564d016983'
AND (
token = 'KbqvSinq5lqzpYa4WkbgNQTCS6Hnq5zVjDd/esMiw00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)