UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GtqhlderQkbdXSkdW4BUMd58B/8M7oV+GGH1McCioo='
WHERE
key_id = '97441cd296da0e25a2f512dccad2d6859fb9a986e082ffee9421a4e6841a1b31'
AND (
token = '6GtqhlderQkbdXSkdW4BUMd58B/8M7oV+GGH1McCioo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)