UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '05lA7gdWvzN8OxRGcR/C09V7sPEnQN4IX/Ir6G0aMtk='
WHERE
key_id = 'c726e60b9d14a42d377b583cc2ef0ff31e88325108a87e49d4763b3e4f3e761b'
AND (
token = '05lA7gdWvzN8OxRGcR/C09V7sPEnQN4IX/Ir6G0aMtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)