UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hq0vgCBNss3i0o+TszLUwzOjZCXyTgocoV4tGuD+Uk4='
WHERE
key_id = 'd642cb8c4166168ed12f644fe7d5f56fcb63422765c6a6f79826e39602a2d21f'
AND (
token = 'Hq0vgCBNss3i0o+TszLUwzOjZCXyTgocoV4tGuD+Uk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)