UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aCcZkWOKoj67cUFKpuvFoKaj63bXL4/Myq37o/YMO2U='
WHERE
key_id = '1f679cbc0cf96b8b9f9a268b971b10b0ade9219111290e10509d81f0602abbff'
AND (
token = 'aCcZkWOKoj67cUFKpuvFoKaj63bXL4/Myq37o/YMO2U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)