UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AFQi9PL/ihDf6tD+DhFGZ7AYaUKBkLlPbUx/G1n9S3I='
WHERE
key_id = '48389942e2b7d5cb9b096d3c199b4ca7e55ed6abca29d8c8924cfadf60ac78fc'
AND (
token = 'AFQi9PL/ihDf6tD+DhFGZ7AYaUKBkLlPbUx/G1n9S3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)