UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8gprQi/90sK5esBgNM7A2EGpnqotlXITy8g3viQNvE='
WHERE
key_id = 'd4d4f48499076875bfe9c8caddeeb4488d7e828687e4427ffe6a1b7810dbdece'
AND (
token = 'X8gprQi/90sK5esBgNM7A2EGpnqotlXITy8g3viQNvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)