UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gILuOSF4t0u7JcVzlKdrDOTK0cKVKipEgsw6EaE9dso='
WHERE
key_id = 'c72b09c9d3e2cc7246a5c7c3c71d35730cbb1a704772adc2f2ed890208a92429'
AND (
token = 'gILuOSF4t0u7JcVzlKdrDOTK0cKVKipEgsw6EaE9dso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)