UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qBSyu0p2oiq47P3lwgdkB0UzezEpsKMf4vqrHNgd+g='
WHERE
key_id = '0f21074c1c2e522d0e4e84772ce9762b08c012771b012f882918f447e79c1348'
AND (
token = '8qBSyu0p2oiq47P3lwgdkB0UzezEpsKMf4vqrHNgd+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)