UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ccGyvCzk4UnUQTW0eOyqygvv4536qSnX1pWUkoNl9B4='
WHERE
key_id = '47a85b410dca8ddb8412ff3a7025caab9f94a19892d126e4e5dd8208cc456c76'
AND (
token = 'ccGyvCzk4UnUQTW0eOyqygvv4536qSnX1pWUkoNl9B4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)