UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HDJCLXd1eiBouUv44mib3HiY1/T7ZQrrlOcUHEoPNRo='
WHERE
key_id = '9c68fcfee9b7bfb76c4959965fe07e2a1eb8719e9e0d0e797dfa668ae628bb39'
AND (
token = 'HDJCLXd1eiBouUv44mib3HiY1/T7ZQrrlOcUHEoPNRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)