UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3hhkv8SwxAL5TZJN77kahdzlt4gMUP77Nw3uvQ5h3Tg=' 
WHERE 
  key_id = 'cb931832cd2a92236ca135e1cf25b111053a22d01b947e962bbe782e0e5fcfa2' 
  AND (
    token = '3hhkv8SwxAL5TZJN77kahdzlt4gMUP77Nw3uvQ5h3Tg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035