UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZZIkJ7j0gzwZgUdoZQxNPylq+/Sc/beOpQPYc/vB9U='
WHERE
key_id = '3eb86a66087798a113d15157aacd4eafca29604a67afb6048855468e9512dcde'
AND (
token = 'gZZIkJ7j0gzwZgUdoZQxNPylq+/Sc/beOpQPYc/vB9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)