UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CP343ziqTvqacpg5xbuZH32d3uGjZg6H18+QxV7v6fA='
WHERE
key_id = '25f8102cfb0f0f47f3f1712186bc9cf533727cc9200afa59d4cede430a768d46'
AND (
token = 'CP343ziqTvqacpg5xbuZH32d3uGjZg6H18+QxV7v6fA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)