UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'akNTKcXK1DQVtXN1VOuFVd1dPjIqWRY562hEW06yJVs='
WHERE
key_id = '7ad7c4dd43ed882a240ae978b4fc379b7e73c12ecfb472086fe61fe408a4af96'
AND (
token = 'akNTKcXK1DQVtXN1VOuFVd1dPjIqWRY562hEW06yJVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)