UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CvGdmtz8WCqNb+wmoIWgod5NW6tr/ohJgoxksGf375M='
WHERE
key_id = '29d7d457a9cb3f8596f2652fb9c3148c0e174e9083b11d8fe995a53360a17208'
AND (
token = 'CvGdmtz8WCqNb+wmoIWgod5NW6tr/ohJgoxksGf375M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)