UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '26w6xbzEdwOiMM7ri18F0Xq9waOaS1yjKWgXG9UIsaY='
WHERE
key_id = '1f1f19f39b3a96649219e10e44ee153d119d7d50cf5a9efb97df3e4eac8eda4a'
AND (
token = '26w6xbzEdwOiMM7ri18F0Xq9waOaS1yjKWgXG9UIsaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)