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