UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WZX8JFmjaML1lpIVcowWOWW0ZKLCOgVX3wXviGrXDhw='
WHERE
key_id = '1fbe8204195f67d57180622f32ae05664345219e2c1c85810ecbb86bdb179fbe'
AND (
token = 'WZX8JFmjaML1lpIVcowWOWW0ZKLCOgVX3wXviGrXDhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)