UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cgfxpk31gv9s4CM0ErUag57EbErw1mc+Q6TPVQCufyo='
WHERE
key_id = 'db9f7b2b29ff33afafc87f51b1f261cc74a3602c0626ccf507ac187553b82233'
AND (
token = 'cgfxpk31gv9s4CM0ErUag57EbErw1mc+Q6TPVQCufyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)