UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZoBCyC6FbqzdReUniJk6AXOYdyxd3mOxVoFGgMm5eR8='
WHERE
key_id = '1559986ad368c2d6102e0e431524a9f18f0d1611fbcd78e387af50d795bda52a'
AND (
token = 'ZoBCyC6FbqzdReUniJk6AXOYdyxd3mOxVoFGgMm5eR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)