UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GDXLQ2J6qMpdL/JvsYsWcjV9yH35acemh4pevMwn2Q='
WHERE
key_id = '2c123875d8a353d48011bde05e933e82a4a1f6e53418e9dbe456afed18bff048'
AND (
token = '8GDXLQ2J6qMpdL/JvsYsWcjV9yH35acemh4pevMwn2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)