UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c8VEbZKui9JJWBiIq+G4Gk1DBAMcTYDl9ofYxYETKkY='
WHERE
key_id = '3dd1e624fc85b359ab5713f3ad9596c3be19d1b48cb16ac679887c6c188f9061'
AND (
token = 'c8VEbZKui9JJWBiIq+G4Gk1DBAMcTYDl9ofYxYETKkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)