UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7noXvmQa3tHCFCxH9ICuoorhXLy/eesAHNiArg6ZROg='
WHERE
key_id = 'f6ae42157b8cfcb1561caafe9d9744379d7cf292d47e95a053e45e4216e04d09'
AND (
token = '7noXvmQa3tHCFCxH9ICuoorhXLy/eesAHNiArg6ZROg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)