UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hcnFcgGuLzcm7fXtuIrTlTKv8cTVSBXUGDalvPDNxvQ='
WHERE
key_id = 'beeeac1a0db95bf07cceab9b714750c1131e09a7d80faf9c686bb748d861ad26'
AND (
token = 'hcnFcgGuLzcm7fXtuIrTlTKv8cTVSBXUGDalvPDNxvQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)