UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kTCD4uc4u1eX2GqRHcN5lJ7Voq61DBrgNVzpwv/diaw='
WHERE
key_id = '306b7e84ef72206dcdef0894fffee1549fc1cdcd5062832e3c7887e94446a1c8'
AND (
token = 'kTCD4uc4u1eX2GqRHcN5lJ7Voq61DBrgNVzpwv/diaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)