UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QO2aYhkvChYEQ+M9k6aYxzb9wIPXPFcBVvEO3nRoV44='
WHERE
key_id = '39492d6306bdf2e050b13ec3399be3f8b82efc63990fd52ae86d185c8b79c3a2'
AND (
token = 'QO2aYhkvChYEQ+M9k6aYxzb9wIPXPFcBVvEO3nRoV44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)